package com.lcc.book.demos.web.Mapper;

import com.lcc.book.demos.web.Model.BookInfo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;


@Mapper
public interface BookInfoMapper {
    /**
     * 获取当前页的信息
     * @param offset 起始id
     * @param pageSize 每页记录条数
     * @return
     */
    @Select("select * from book_info where status !=0 " +
            "order by id desc limit #{offset},#{pageSize}")
    List<BookInfo> selectBookInfoByPage(@Param("offset") Integer offset, @Param("pageSize") Integer pageSize);
    @Select("select count(1) from book_info where status != 0")
    Integer count();

    @Insert("insert into book_info (book_name,author,count,price,publish,status) values (#{bookName},#{author},#{count},#{price},#{publish},#{status})")
    Integer addBookInfo(BookInfo bookInfo);

    @Select("select * from book_info where id= #{bookId}")
    BookInfo selectBookInfoById(Integer bookId);

    Integer updateBookInfo(BookInfo bookInfo);

    Integer batchDelete(@Param("ids") List<Integer> ids);
}
